Computer science Lesson Plan
Class: 5 - Lesson:6.2 Spreadsheet (Create a student mark sheet).

Purpose: Students should learn the special features of spreadsheets,freeze the rows/columns,find and replace.

No. of Classes

One or two classes (Teacher's decision).

Material Required

Open office(Spreadsheet).

Curriculum Content
  • 7) Open office - Spread sheet
  • 7.1) Spread sheet basics
  • 7.2) Cell properties
  • 5.2.17) Freeze rows and columns.
  • 5.2.18) Sort sheet by columns.
  • 5.2.14)Find, replace.
    •

    Prior knowledge

    Students should know about basics of spreadsheets.

    Exercise

    Exercise:1


    1.Create a new spreadsheet and name it as ‘student mark sheet.ods’. Use formulae to calculate Total and Average.

    Exercise:2


    2.How do you sort and freeze rows/columns in a spreadsheet?.

    Exercise:3


    3. How do you Find and Replace words?.

    Solution


  • Link to copy the solution spreadsheet
  • Link to view the solution video for exercise 1
  • Link to view the solution video for exercise 2 & 3

    • Teacher's Instruction
    1. Teachers should ensure that the students understand simple operations like Addition, Subtraction, Multiplication, and Division, before giving the Exercise.
    2. Students should identify the number of rows and columns before creating the spreadsheet.
    3. Teachers should explain about the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days, or S.No).
    4. Teachers should ensure that all Students understand the freezing rows and columns feature and sort columns, and also how to highlight the header row by using shadows for that row.
    5. To know the formula of a specific cell, the formula bar at the top left of the sheet can be referred to.